{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["BASIC DATA","FF-1 (S&U)","FF-2 (MCC)","FF-3 (MAE)","FF-4 (MDPP)","FF-5 (DEBT SERVICE)","FF-6 (MPUS)","FF-7 (CERTIFICATION)","Factor"],"not_rendered":{"charts":0,"images":19,"macros":1,"external_links":0,"defined_names":23,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BASIC DATA","index":0,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,1,2,10],[13,6,13,8],[7,6,7,7],[9,6,9,9],[11,6,11,9]]}
[]
[]
[null,"FINANCIAL FEASIBILITY FORMS"]
[]
[null,"Please complete the following information before proceeding:"]
[]
[]
[null,null,"Application Date:"]
[]
[null,null,"Ownership Entity:"]
[]
[null,null,"Project Name:"]
[]
[null,null,"Project Location (County)",null,null,null,1]
[]
[null,null,"Type of Construction:",null,null,null,1]
[]
[null,null,"Project Type:",null,null,null,1]
[]
[null,null,"Target Population:",null,null,null,1]
[]
[null,null,"Total Number of Units:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2,"New Construction"]
[3,"Moderate Rehabilitation"]
[4,"Substantial Rehabilitation (stripped to studs)"]
[5,"Historic Rehabilitation"]
[1]
[2,"Multifamily"]
[3,"Single-Family (Attached)"]
[4,"Single-Family (Detached)"]

{"sheet":"FF-1 (S&U)","index":1,"n_rows":55,"n_cols":11,"rows_kept":55,"cut":false,"hidden":false,"merged":[[46,5,46,7],[47,5,47,7],[48,5,48,7],[49,5,49,7],[12,3,12,6],[30,3,30,6],[45,5,45,7],[23,5,23,7],[24,5,24,7],[25,5,25,7],[27,11,27,13],[14,11,14,13],[20,11,20,13],[16,11,16,13],[18,11,18,13],[19,11,19,13],[8,2,8,13],[9,2,9,13],[6,2,6,13],[7,2,7,13],[21,5,21,7],[22,5,22,7]]}
[]
[]
[null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[null,null,"SOURCES AND USES SUMMARY "]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[]
[null,null,null,"SOURCES OF FUNDS"]
[]
[null,null,null,"HOME/HTF Funds Request:",null,null,null,null,null,null,0]
[null,null,null,"Loans",null,null,null,null,null,null,0]
[null,null,null,"Federal Funds",null,null,null,null,null,null,0]
[null,null,null,"Non-Federal Funds",null,null,null,null,null,null,0]
[null,null,null,"State/Local Funds",null,null,null,null,null,null,0]
[null,null,null,"Housing Tax Credits Syndication Proceeds",null,null,null,null,null,null,0]
[null,null,null,"Deferred Developer Fee",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[]
[null,null,null,"Total Sources:  ",null,null,null,null,null,null,{"$f":"SUM(K15:K26)","v":0}]
[]
[]
[null,null,null,"USES OF FUNDS"]
[]
[null,null,null,"Acquisition Costs",null,null,null,null,null,null,0]
[null,null,null,"Site Work Costs",null,null,null,null,null,null,0]
[null,null,null,"Construction/Rehabilitation Costs",null,null,null,null,null,null,0]
[null,null,null,"General Contractors Fees",null,null,null,null,null,null,0]
[null,null,null,"Professional Fees",null,null,null,null,null,null,0]
[null,null,null,"Construction Financing Costs",null,null,null,null,null,null,0]
[null,null,null,"Construction Interim Costs",null,null,null,null,null,null,0]
[null,null,null,"Permanent Financing Fees and Expenses",null,null,null,null,null,null,0]
[null,null,null,"Owner Costs",null,null,null,null,null,null,0]
[null,null,null,"Partnership Costs",null,null,null,null,null,null,0]
[null,null,null,"Developer Fees",null,null,null,null,null,null,0]
[null,null,null,"Reserves",null,null,null,null,null,null,0]
[null,null,null,"Admin and Mgmt Costs",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[null,null,null,"Other:",null,null,null,null,null,null,0]
[]
[null,null,null,"Total Uses:",null,null,null,null,null,null,{"$f":"SUM(K33:K50)","v":0}]
[]
[]
[null,null,null,"Gap:",null,null,null,null,null,null,{"$f":"K28-K52","v":0}]

{"sheet":"FF-2 (MCC)","index":2,"n_rows":63,"n_cols":43,"rows_kept":63,"cut":false,"hidden":false,"merged":[[6,2,6,22],[8,2,8,22],[50,12,50,15],[24,19,24,20],[29,19,29,20],[42,3,42,21],[39,19,39,20],[48,12,48,15],[34,11,34,18],[35,11,35,18],[67,4,67,21],[15,3,15,21],[31,3,31,21],[41,4,41,22],[19,19,19,20],[20,19,20,20],[64,4,64,21],[59,17,59,18],[55,3,55,21],[28,19,28,20],[57,4,57,21],[9,2,9,22],[10,2,10,22],[12,2,12,22],[23,19,23,20],[46,12,46,15],[36,11,36,18],[37,11,37,18],[47,38,47,39],[52,19,52,20],[39,26,39,28],[46,38,46,39],[41,39,41,40],[27,19,27,20],[28,33,28,35]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null,"MAXIMUM CONSTRUCTION COSTS (MCC)"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[null,null,"Maximum Construction Costs are calculated based on the criteria listed below.  If the project's estimated hard costs per unit exceed the established limits, then all factors that contributed to the excess per unit cost (e.g. exceptionally high land costs, material costs, special wage rates) are required to be disclosed and fully explained.  Justification for the excess cost must be certified by the project's architect.  Excessive land development costs must be certified by an engineer."]
[]
[]
[null,null,null,"MAXIMUM CONSTRUCTION COST (MCC)"]
[]
[]
[null,null,null,null,null,"NEW CONSTRUCTION MULTIFAMILY DEVELOPMENTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost per Unit"]
[null,null,null,null,null,null,null,"Family……………………………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,170400]
[null,null,null,null,null,null,null,"Elderly/Persons with Disabilities……………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,130800]
[]
[null,null,null,null,null,"NEW CONSTRUCTION SINGLE FAMILY DEVELOPMENTS"]
[null,null,null,null,null,null,null,"Single Family - Attached (Townhomes/Duplexes/4-plex)……………………………………………….",null,null,null,null,null,null,null,null,null,null,null,164400,null,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!G18=3,\"x\",\"\")","v":""},3,"SF-A",null,null,null,{"$f":"IF('BASIC DATA'!G16=3,\"X\",\"\")","v":""},3,"Moderate Rehabilitation",null,null,{"$f":"IF('BASIC DATA'!G20=3,\"x\",\"\")","v":""},3,"Elderly/Disabled"]
[null,null,null,null,null,null,null,"Single Family - Detached……………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,182400,null,null,null,null,null,null,null,{"$f":"IF('BASIC DATA'!G18=4,\"x\",\"\")","v":""},4,"SF-D",null,null,null,{"$f":"IF('BASIC DATA'!G16=4,\"X\",\"\")","v":""},4,"Substantial Rehabilitation"]
[]
[null,null,null,null,null,"REHABILITATION DEVELOPMENTS"]
[null,null,null,null,null,null,null,"Moderate Rehabilitation..………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,58200]
[null,null,null,null,null,null,null,"Substantial Rehabilitation (stripped to the studs)………………...………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,125400,null,null,null,null,null,null,null,"Dev Type",null,null,null,null,null,"Const Type",null,null,null,null,null,null,"Population"]
[null,null,null,null,null,null,null,"Historic Rehabilitation…………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,181200,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=\"x\",1,0)","v":{"$error":"#REF!"}}]
[]
[null,null,null,"DEVELOPMENT'S ALLOWABLE MAXIMUM CONSTRUCTION COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Multifamily","Single Family",null,null,"SF-A","SF-D"]
[null,null,null,null,null,{"$f":"C10","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dev Type",null,null,{"$f":"'BASIC DATA'!G18","v":1},null,{"$f":"IF(AD34>1,\"True\",\"\")","v":""},null,null,null,null,{"$f":"IF(AD34=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD34>2,\"Yes\",\"No\")","v":"No"},null,null,{"$f":"IF(AD34=3,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD34=4,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,"Development Type:",null,null,{"$f":"VLOOKUP('BASIC DATA'!G18,'BASIC DATA'!A41:B44,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Construction",null,null,{"$f":"'BASIC DATA'!G16","v":1},null,{"$f":"IF(AD35>1,\"True\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"Construction Type:",null,null,{"$f":"VLOOKUP('BASIC DATA'!G16,'BASIC DATA'!A36:B40,2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Population",null,null,{"$f":"'BASIC DATA'!G20","v":1},null,{"$f":"IF(AD36>1,\"True\",\"\")","v":""},null,null,null,null,"NC","AR"]
[null,null,null,null,null,null,null,null,"Targeted Population:",null,null,{"$f":"IF(AF36=\"True\",(IF(AD36=3,\"Elderly/Persons with Disabilities\",\"Family\")),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD35=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD35>=3,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,"Number of Units:",null,null,{"$f":"IF('BASIC DATA'!G22=\"\",\"\",'BASIC DATA'!G22)","v":""}]
[]
[null,null,null,null,null,"Maximum Allowable Construction Cost Per Unit……………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD54","v":0},null,null,null,null,null,null,{"$f":"(T40*0.1)+T40","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Family","Elderly/Dis",null,null,"AJ41"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AD36=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF(AD36=3,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF(AL42=\"Yes\",105500,0)","v":0}]
[null,null,null,"DEVELOPMENT'S PROPOSED CONSTRUCTION COSTS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E","H"]
[]
[]
[null,null,null,null,null,null,null,null,"Total Hard Costs:",null,null,null,{"$f":"IF('FF-1 (S&U)'!K35=\"\",\"\",'FF-1 (S&U)'!K35)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family-A",null,null,{"$f":"IF(AO34=\"Yes\",(IF(AL50<1,MAX(AE47,AF47,AG47,\"0\"),0)),0)","v":0},{"$f":"IF(AO34=\"Yes\",107500,0)","v":0},{"$f":"IF($AL$42=\"Yes\",105500,0)","v":0},{"$f":"IF($AO$48=\"Yes\",131600,0)","v":0},null,null,{"$f":"IF(AL42=\"Yes\",1,0)","v":0},"New Const","Mod Rehab","Sub Rehab",null,"Hist Rehab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single Family-D",null,null,{"$f":"IF(AP34=\"Yes\",(IF(AL50<1,MAX(AE48,AF48,AG48,\"0\"),0)),0)","v":0},{"$f":"IF(AP34=\"Yes\",140000,0)","v":0},{"$f":"IF($AL$42=\"Yes\",105500,0)","v":0},{"$f":"IF($AO$48=\"Yes\",131600,0)","v":0},null,null,null,{"$f":"IF('BASIC DATA'!G16=2,\"Yes\",\"No\")","v":"No"},{"$f":"IF('BASIC DATA'!G16=3,\"Yes\",\"No\")","v":"No"},{"$f":"IF('BASIC DATA'!G16=4,\"Yes\",\"No\")","v":"No"},null,{"$f":"IF('BASIC DATA'!G16=5,\"Yes\",\"No\")","v":"No"}]
[null,null,null,null,null,null,null,null,"Total Builder's Profit and Soft Costs:",null,null,null,{"$f":"'FF-1 (S&U)'!K52-'FF-1 (S&U)'!K35","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"MF NC Family",null,null,{"$f":"IF(AL54=\"MNC\",(IF(AK42=\"Yes\",MAX(AE49,AF49,AG49,0),0)),0)","v":0},{"$f":"IF(AL54=\"MNC\",107000,0)","v":0},{"$f":"IF($AL$42=\"Yes\",105500,0)","v":0},{"$f":"IF($AO$48=\"Yes\",131600,0)","v":0},null,null,null,null,{"$f":"IF(AL48=\"yes\",1,0)","v":0},{"$f":"IF(AM48=\"Yes\",1,0)","v":0},null,{"$f":"IF(AO48=\"Yes\",131600,0)","v":0},"AK48"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF NC Elderly",null,null,{"$f":"IF(AL54=\"MNC\",(IF(AL42=\"Yes\",MAX(AE50,AF50,AG50,0),0)),0)","v":0},{"$f":"IF(AL54=\"MNC\",117000,0)","v":0},{"$f":"IF($AL$42=\"Yes\",105500,0)","v":0},{"$f":"IF($AO$48=\"Yes\",131600,0)","v":0},null,null,null,null,{"$f":"AM49+AL49","v":0}]
[null,null,null,null,null,null,null,null,"Total Development Costs:",null,null,null,{"$f":"M47+M49","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"MF Mod Rehab",null,null,{"$f":"IF(AL48=\"yes\",42000,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MF Sub Rehab",null,null,{"$f":"IF(AM48=\"Yes\",90950,0)","v":0},null,{"$f":"IF(AM48=\"Yes\",(IF(AL56=\"MAR\",T29,\"0\")),\"\")","v":""}]
[null,null,null,null,null,"Development's Proposed Construction Hard Cost Per Unit………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M47=0,0,M47/L38)","v":0},null,null,null,null,null,null,"MF Hist Rehab",null,null,{"$f":"IF(AO48=\"Yes\",(IF(AH53=0,131600,\"0\")),\"\")","v":""},null,null,null,{"$f":"SUM(AD47:AD52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AD47:AD53)","v":0},null,null,null,null,null,null,null,{"$f":"IF(AK34=\"Yes\",(IF(AK37=\"Yes\",\"MNC\",\"0\")),\"\")","v":""},null,"Multifamily New Construction"]
[]
[null,null,null,"EXCEEDING MAXIMUM COSTS PER UNIT LIMITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK34=\"Yes\",(IF(AL37=\"Yes\",\"MAR\",\"0\")),\"\")","v":""},null,"Multifamily Acq Rehab"]
[]
[null,null,null,null,"Construction/Rehabilitation hard costs which exceed the Maximum Construction Cost (MCC) per unit by greater than ten percent (10%) must submit a request for approval to MHC at least fifteen (15) business days prior to the application cycle opening date.  Failure to receive prior approval will disqualify the application from consideration."]
[]
[null,null,null,null,null,null,"This development exceeds the maximum allowable cost per unit by:",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(T53>=T40,T53-T40,\"$0\")","v":0},null,{"$f":"IF(M47=0,\"\",R60/T40)","v":""}]
[]
[]
[null,null,null,null,null,null,"Justification Needed:",null,null,null,{"$f":"IF(T53>AA40,\"x\",\"\")","v":""}," Yes",null,{"$f":"IF(T53<=AA40,\"x\",\"\")","v":"x"}," No"]

{"sheet":"FF-3 (MAE)","index":3,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[8,2,8,18],[6,2,6,18],[9,2,9,18],[10,2,10,18],[12,2,12,18]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null,"MAXIMUM ADMINISTRATIVE EXPENSES (MAE)"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[null,null,"Maximum Administrative Expenses are calculated based on the criteria listed below.  If an application has administrative expenses in excess of the established limits, all factors that contributed to the excess (e.g., exceptionally high insurance costs, maintenance reserves, replacement reserves, significant amenities and/or services, requirement of security, high real estate taxes and/or insurance, etc.) are required to be disclosed and fully explained within the application by a certified CPA.  In addition to a maximum expense per unit, MHC will require a minimum expense per unit of $2,700 that must be maintained throughout the compliance period."]
[]
[null,null,"Check the appropriate box.  Select only one box from each category."]
[]
[]
[null,null,"Development Base (DB)…………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U24>5018,0,U24)","v":0}]
[null,null,"(Includes Section 8 - Family, All Elderly/Handicapped, All Family/ Non-Elderly)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U24=9487,\"ERROR\",\"\")","v":""}]
[]
[null,null,null,null,false,null,"Metropolitan Areas",null,null,null,null,null,null,5707,null,null,null,null,null,null,{"$f":"IF(E21=TRUE,N21,\"\")","v":""}]
[]
[null,null,null,null,false,null,"All Other Areas",null,null,null,null,null,null,5140,null,null,null,null,null,null,{"$f":"IF(E23=TRUE,N23,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U21:U23)","v":0}]
[null,null,"Development Designation (DD)………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U34>1,0,V33)","v":0}]
[]
[null,null,null,null,false,null,"All Senior Citizens",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U34>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E27=TRUE,N27,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Mixed",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E29=TRUE,N29,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Congregate",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E31=TRUE,N31,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Family",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E33=TRUE,N33,\"\")","v":""},{"$f":"SUM(U27:U33)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U27:U33)","v":0}]
[null,null,"Development Size (DS)…………………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U44>1,0,V43)","v":0}]
[]
[null,null,null,null,false,null,"50 or more units",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U44>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E37=TRUE,N37,\"\")","v":""}]
[]
[null,null,null,null,false,null,"33 - 49 units",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E39=TRUE,N39,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E41=TRUE,N41,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units (scattered sites, different locations/municipalities)",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E43=TRUE,N43,\"\")","v":""},{"$f":"SUM(U37:U43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U37:U43)","v":0}]
[null,null,"Management Difficulty (MD)………………………………………………………………………………………………….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U56>1,0,V55)","v":0}]
[]
[null,null,null,null,false,null,"Full Profit",null,null,null,null,null,null,0.9,null,null,null,{"$f":"IF(U56>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E47=TRUE,N47,\"\")","v":""}]
[]
[null,null,null,null,false,null,"515 / Market Rate",null,null,null,null,null,null,0.95,null,null,null,null,null,null,{"$f":"IF(E49=TRUE,N49,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Split RA",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E51=TRUE,N51,\"\")","v":""}]
[]
[null,null,null,null,false,null,"100% RA / Split Section 8",null,null,null,null,null,null,1.05,null,null,null,null,null,null,{"$f":"IF(E53=TRUE,N53,\"\")","v":""}]
[]
[null,null,null,null,false,null,"100% Section 8 / 515",null,null,null,null,null,null,1.1000000000000001,null,null,null,null,null,null,{"$f":"IF(E55=TRUE,N55,\"\")","v":""},{"$f":"SUM(U47:U55)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U47:U55)","v":0}]
[null,null,"Development Location (DL) ……………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U62>1,0,V61)","v":0}]
[]
[null,null,null,null,false,null,"Harrison, Hancock and Jackson",null,null,null,null,null,null,1.25,null,null,null,{"$f":"IF(U62>1,\"ERROR\",\"\")","v":""},null,null,{"$f":"IF(E59=TRUE,N59,\"\")","v":""}]
[]
[null,null,null,null,false,null,"Other Counties",null,null,null,null,null,null,1,null,null,null,null,null,null,{"$f":"IF(E61=TRUE,N61,\"\")","v":""},{"$f":"SUM(U59:U61)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(U59:U61)","v":0}]
[]
[]
[]
[null,null,"Calculations:"]
[]
[null,null,"Maximum Administrative Expenses (MAE) Per Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R18*R25*R35*R45*R57","v":0}]
[null,null,"($DB) x (DD) x (DS) x (MD) x (DL) = MAE"]

{"sheet":"FF-4 (MDPP)","index":4,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[8,2,8,16],[9,2,9,16],[10,2,10,16],[12,2,12,16]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null," MAXIMUM DEVELOPER PROFIT PERCENTAGE (MDPP)"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[null,null,"MHC will allow a base fee of fifteen percent (15%) of the development's construction costs, incuding builder's profit, for developer's fees which includes developer's overhead and consultant fees.  This base fee may be increased dependent upon the development size.  For developments which qualify for acquisition credits, MHC will permit a flat developer fee of ten percent (10%) on the development's allowable acquisition cost."]
[]
[]
[null,null,"Base Fee...……………………………………………………………………………………………………………………………..",null,null,null,null,null,null,null,null,null,null,null,null,null,0.15]
[]
[]
[null,null,"Please select only one from each category."]
[]
[null,null,"Development Size (DS)…………………………………………………………………………………………………………",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S29>1,0,T27)","v":0}]
[]
[null,null,null,null,false,null,"33 or more units",null,null,null,null,null,null,null,1,null,{"$f":"IF(S29>1,\"ERROR\",\"\")","v":""},null,{"$f":"IF(E23=TRUE,O23,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units",null,null,null,null,null,null,null,1.1000000000000001,null,null,null,{"$f":"IF(E25=TRUE,O25,\"\")","v":""}]
[]
[null,null,null,null,false,null,"24 - 32 units (scattered sites, different locations/municipalities)",null,null,null,null,null,null,null,1.2,null,null,null,{"$f":"IF(E27=TRUE,O27,\"\")","v":""},{"$f":"SUM(S23:S27)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(S23:S27)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calculations:"]
[]
[null,null,"Maximum Developer Profit Percentage (MDPP)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q16*Q21","v":0}]
[null,null,"Base (15%) x (DS) = MDPP"]

{"sheet":"FF-5 (DEBT SERVICE)","index":5,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":false,"merged":[[25,3,25,15],[15,5,15,15],[17,5,17,15],[8,2,8,15],[18,5,18,15],[16,7,16,15],[9,2,9,15],[10,2,10,15],[12,2,12,15]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null," DEBT SERVICE COVERAGE RATIO (DSCR)"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[null,null,"All projects must reflect a 15-year average Debt Service Coverage Ratio (DSCR) between 1.15 and 1.30.  A development will not be considered financially feasible if the average DSCR does not fall within the aforementioned range.  "]
[]
[]
[null,null,null,null,null,"The above referenced proposed project's average DSCR falls within the required range."]
[]
[null,null,null,null,null,"The above referenced proposed project exceeds the debt service beyond the acceptable"]
[null,null,null,null,null,"acceptable range.  Prior to receiving a reservation, the developer will:"]
[]
[null,null,null,null,null,null,null,null,null,"obtain a higher permanent mortgage supported by a debt service coverage within the"]
[null,null,null,null,null,null,null,null,null,"acceptable range, or"]
[]
[null,null,null,null,null,null,null,null,null,"reduce the rents that would be charged to the tenant."]
[]
[null,null,null,"A project is not considered feasible for tax credits if the average debt service coverage ratio does not fall within the aforementioned range.  The minimum debt service coverage ratio will be enforced."]
[null,null,null,"Maximum Supportable Mortgage Worksheet"]
[]
[null,null,null,null,null,null,null,null,null,null,"Year","Amount Available for Debt Service","Debt Service Payment","DSCR"]
[null,null,null,null,null,null,null,null,null,null,1,0,0,{"$f":"IF(L30=0,\"\",L30/M30)","v":""}]
[null,null,null,null,null,null,null,null,null,null,2,0,0,""]
[null,null,null,null,null,null,null,null,null,null,3,0,0,""]
[null,null,null,null,null,null,null,null,null,null,4,0,0,""]
[null,null,null,null,null,null,null,null,null,null,5,0,0,""]
[null,null,null,null,null,null,null,null,null,null,6,0,0,""]
[null,null,null,null,null,null,null,null,null,null,7,0,0,""]
[null,null,null,null,null,null,null,null,null,null,8,0,0,""]
[null,null,null,null,null,null,null,null,null,null,9,0,0,""]
[null,null,null,null,null,null,null,null,null,null,10,0,0,""]
[null,null,null,null,null,null,null,null,null,null,11,0,0,""]
[null,null,null,null,null,null,null,null,null,null,12,0,0,""]
[null,null,null,null,null,null,null,null,null,null,13,0,0,""]
[null,null,null,null,null,null,null,null,null,null,14,0,0,""]
[null,null,null,null,null,null,null,null,null,null,15,0,0,""]
[null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(L30:L44)","v":0},{"$f":"SUM(M30:M44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Avg:",{"$f":"L45/15","v":0},{"$f":"M45/15","v":0},{"$f":"IF(N44=\"\",\"\",AVERAGE(N30:N44))","v":""}]

{"sheet":"FF-6 (MPUS)","index":6,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":false,"merged":[[15,4,15,7],[16,4,16,7],[17,4,17,7],[18,4,18,7],[19,4,19,7],[6,2,6,11],[8,2,8,11],[9,2,9,11],[11,2,11,11],[14,4,14,7]]}
[]
[]
[null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null,"MAXIMUM Per Unit Subsidy (MPUS)"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[]
[null,null,"Maximum Per Unit Subsidy limits are established annually by HUD.  These per unit limits are not automatically granted to a development.  MHC will conduct a project feasibility analysis and subsidy layering review analysis to determine the amount of funding needed  to make the project feasible and viable throughout the affordability period.  The limits on this worksheet are only used for guideline purposes and does not represent the amount of funds that will be awarded to a development."]
[]
[]
[null,null,null,null,"Bedrooms",null,null,null,"234 Basic Elevator-Type Limit","High Cost Percentage","Maximum Per Unit Subsidy Limit (MPUS)"]
[null,null,null,null,"0 Bedrooms",null,null,null,72088,2.7,{"$f":"I16*J16","v":194637.6},null,null,{"$f":"IF(#REF!=TRUE,#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"1 Bedroom",null,null,null,82638,2.7,{"$f":"I17*J17","v":223122.6},null,null,{"$f":"IF(#REF!=TRUE,#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"2 Bedrooms",null,null,null,100490,2.7,{"$f":"I18*J18","v":271323},null,null,{"$f":"IF(#REF!=TRUE,#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"3 Bedrooms",null,null,null,130002,2.7,{"$f":"I19*J19","v":351005.4},null,null,{"$f":"IF(#REF!=TRUE,#REF!,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,"4 Bedrooms",null,null,null,142701,2.7,{"$f":"I20*J20","v":385292.7},null,null,{"$f":"IF(#REF!=TRUE,#REF!,\"\")","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N16:N17)","v":{"$error":"#REF!"}}]
[null,null,"Development Bedroom Units Mix"]
[]
[null,null,null,null,"Bedrooms ",null,null,null,null,"Number of Units","Max Subsidy Limit"]
[]
[null,null,null,null,"Number of units with 0 Bedrooms:",null,null,null,null,null,{"$f":"K16*J27","v":0},null,null,{"$f":"IF(E27=TRUE,#REF!,\"\")","v":""}]
[null,null,null,null,"Number of units with 1 Bedrooms:",null,null,null,null,null,{"$f":"K17*J28","v":0},null,null,{"$f":"IF(E28=TRUE,#REF!,\"\")","v":""}]
[null,null,null,null,"Number of units with 2 Bedrooms:",null,null,null,null,null,{"$f":"K18*J29","v":0},null,null,{"$f":"IF(E29=TRUE,#REF!,\"\")","v":""}]
[null,null,null,null,"Number of units with 3 Bedrooms:",null,null,null,null,null,{"$f":"K19*J30","v":0}]
[null,null,null,null,"Number of units with 4 Bedrooms:",null,null,null,null,null,{"$f":"K20*J31","v":0}]
[null,null,null,null,"Totals:",null,null,null,null,{"$f":"SUM(J27:J31)","v":0},{"$f":"SUM(K27:K31)","v":0},null,null,{"$f":"IF(E32=TRUE,#REF!,\"\")","v":""},{"$f":"SUM(N27:N32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(N27:N32)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(#REF!)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E38=TRUE,#REF!,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E40=TRUE,#REF!,\"\")","v":""},{"$f":"SUM(N38:N40)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(N38:N40)","v":0}]
[]
[]
[]
[null,null,"Calculations:"]
[]
[null,null,"Maximum Per Unit Subsidy (MPUS)"]
[null,null,"(Maximum Per Unit Subsidy by number of bedrooms) x Number of Units = MPUS"]

{"sheet":"FF-7 (CERTIFICATION)","index":7,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[8,2,8,17],[9,2,9,17],[14,2,14,16],[28,2,28,13],[33,2,33,16],[25,15,25,16],[17,15,17,16],[21,15,21,16],[23,15,23,16],[19,15,19,16],[10,2,10,17],[12,2,12,17],[46,7,46,9],[31,2,31,16],[40,5,40,12],[41,8,41,12],[43,7,43,12],[27,15,27,16]]}
[]
[]
[null,null,null,null,null,null,null,"MISSISSIPPI HOME CORPORATION"]
[null,null,null,null,null,null,null,"FEDERAL GRANTS PROGRAMS"]
[]
[]
[]
[]
[null,null,"Financial Feasiblity Certification"]
[null,null,{"$f":"IF('BASIC DATA'!G12=\"\",\"\",'BASIC DATA'!G12)","v":""}]
[null,null,{"$f":"IF('BASIC DATA'!G8=\"\",\"\",'BASIC DATA'!G8)","v":""}]
[]
[null,null,"Pursuant to HUD regulations, the dollar amount funded to a project shall not exceed the amount MHC determines is necessary for the financial feasibility of the project and its viability as a qualified low-income housing project throughout the affordability period.   A project will not be considered financially feasible if these standards are not met."]
[]
[null,null,"The following forms have been computed and are being submitted with the HTC Application:"]
[]
[]
[null,null,null,null,null,null,"Form FF-1:  Sources and Uses Statement",null,null,null,null,null,null,null,"Gap= ",{"$f":"IF('FF-1 (S&U)'!K55=\"\",\"\",'FF-1 (S&U)'!K55)","v":0}]
[]
[null,null,null,null,null,null,"Form FF-2:  Maximum Construction Cost Per Unit (MCC)",null,null,null,null,null,null,null,"MCC= ",{"$f":"IF('FF-2 (MCC)'!T53=\"\",\"\",'FF-2 (MCC)'!T53)","v":0}]
[]
[null,null,null,null,null,null,"Form FF-3:  Maximum Administrative Expenses Per Unit (MAE)",null,null,null,null,null,null,null,"MAE= ",{"$f":"IF('FF-3 (MAE)'!R68=0,\"\",'FF-3 (MAE)'!R68)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-4:  Maximum Developer Profit Percentage (MDPP)",null,null,null,null,null,null,null,"MDPP= ",{"$f":"IF('FF-4 (MDPP)'!Q60=0,\"\",'FF-4 (MDPP)'!Q60)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-5:  Debt Service Underwriting Criteria",null,null,null,null,null,null,null,"Avg DSCR= ",{"$f":"IF('FF-5 (DEBT SERVICE)'!N46=\"\",\"\",'FF-5 (DEBT SERVICE)'!N46)","v":""}]
[]
[null,null,null,null,null,null,"Form FF-6:  Maximum Subsidy Limit",null,null,null,null,null,null,null,"MPUS= ",{"$f":"IF('FF-6 (MPUS)'!J32=0,\"\",'FF-6 (MPUS)'!K32)","v":""}]
[]
[]
[]
[null,null,"ACKNOWLEDGEMENT AND CERTIFICATION"]
[]
[null,null,"The undersigned applicant hereby certifies that the information submitted with these Financial Feasibility Forms are true and correct."]
[]
[]
[null,null,"OWNER"]
[null,null,{"$f":"IF('BASIC DATA'!G10=\"\",\"\",'BASIC DATA'!G10)","v":""}]
[]
[]
[null,null,"By:"]
[null,null,null,null,null,"Printed Name:"]
[]
[null,null,null,"Its:"]
[]
[]
[null,null,"Date:"]

{"sheet":"Factor","index":8,"n_rows":86,"n_cols":6,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"Counties",null,null,"Target Population"]
[]
[null,null,"Adams",null,null,"Family"]
[null,null,"Alcorn",null,null,"Elderly/Persons with Disabilities"]
[null,null,"Amite"]
[null,null,"Attala"]
[null,null,"Benton"]
[null,null,"Bolivar"]
[null,null,"Calhoun"]
[null,null,"Carroll"]
[null,null,"Chickasaw"]
[null,null,"Choctaw"]
[null,null,"Claiborne"]
[null,null,"Clarke"]
[null,null,"Clay"]
[null,null,"Coahoma"]
[null,null,"Copiah"]
[null,null,"Covington"]
[null,null,"Desoto"]
[null,null,"Forrest"]
[null,null,"Franklin"]
[null,null,"George"]
[null,null,"Greene"]
[null,null,"Grenada"]
[null,null,"Hancock"]
[null,null,"Harrison"]
[null,null,"Hinds"]
[null,null,"Holmes"]
[null,null,"Humphreys"]
[null,null,"Issaquena"]
[null,null,"Itawamba"]
[null,null,"Jackson"]
[null,null,"Jasper"]
[null,null,"Jefferson"]
[null,null,"Jefferson Davis"]
[null,null,"Jones"]
[null,null,"Kemper"]
[null,null,"Lafayette"]
[null,null,"Lamar"]
[null,null,"Lauderdale"]
[null,null,"Lawrence"]
[null,null,"Leake"]
[null,null,"Lee"]
[null,null,"Leflore"]
[null,null,"Lincoln"]
[null,null,"Lowndes"]
[null,null,"Madison"]
[null,null,"Marion"]
[null,null,"Marshall"]
[null,null,"Monroe"]
[null,null,"Montgomery"]
[null,null,"Neshoba"]
[null,null,"Newton"]
[null,null,"Noxubee"]
[null,null,"Oktibbeha"]
[null,null,"Panola"]
[null,null,"Pearl River"]
[null,null,"Perry"]
[null,null,"Pike"]
[null,null,"Pontotoc"]
[null,null,"Prentiss"]
[null,null,"Quitman"]
[null,null,"Rankin"]
[null,null,"Scott"]
[null,null,"Sharkey"]
[null,null,"Simpson"]
[null,null,"Smith"]
[null,null,"Stone"]
[null,null,"Sunflower"]
[null,null,"Tallahatchie"]
[null,null,"Tate"]
[null,null,"Tippah"]
[null,null,"Tishomingo"]
[null,null,"Tunica"]
[null,null,"Union"]
[null,null,"Walthall"]
[null,null,"Warren"]
[null,null,"Washington"]
[null,null,"Wayne"]
[null,null,"Webster"]
[null,null,"Wilkinson"]
[null,null,"Winston"]
[null,null,"Yalobusha"]
[null,null,"Yazoo"]